Between the key attribute and each non - key attribute bound to columns in the main dimension table 在键属性与绑定到主维度表中各列的每个非键属性之间定义。
Of a database dimension is the attribute to which all non - key attributes in the dimension are linked directly or indirectly 上图所示的多维数据集有四个维度: route 、 service 、 time和measures 。
Between the attribute bound to foreign key in the secondary table and each non - key attribute bound to columns from the secondary table 在绑定到辅助表中外键的属性与绑定到辅助表中各列的每个非键属性之间定义。
For example , you might want to define a natural hierarchy , a custom sort order , or dimension granularity based on a non - key attribute 例如,您可能需要定义自然层次结构、自定义排序顺序或基于非键属性的维度粒度。
If there are no defined relationships between attributes , analysis services will aggregate all non - key attributes from the key attribute 如果属性之间没有定义的关系,则analysis services将根据键属性聚合所有非键属性。
Notice the four attribute relationships that link the non - key attributes from the geography table to the key attribute from the geography table 请注意,用于将geography表的非键属性链接到geography表的键属性的四个成员属性。
If the granularity attribute and the key attribute are different attributes , then non - key attributes must be linked , directly or indirectly , to the granularity attribute 将事务或数据快照从发布服务器移动到订阅服务器,在订阅服务器上,将它们应用于订阅数据库中的目标表。
When you define a dimension based on a star schema , which is where all dimension attributes are derived from the same relational table , an attribute relationship is automatically defined between the key attribute and each non - key attribute of the dimension 当您基于星型架构(在该架构中,所有维度属性都派生自同一关系表)定义维度时,会在维度的键属性与每个非键属性之间自动定义属性关系。